﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsAdvancedRpt" targetNamespace="http://tempuri.org/dsAdvancedRpt.xsd" xmlns:mstns="http://tempuri.org/dsAdvancedRpt.xsd" xmlns="http://tempuri.org/dsAdvancedRpt.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="MLYConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MLYConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.MLYConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TableOTDContractorsTableAdapter" GeneratorDataComponentClassName="TableOTDContractorsTableAdapter" Name="TableOTDContractors" UserDataComponentName="TableOTDContractorsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MLYConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TableWorkOrder.ContractorId, TableOrganizations.OrganizationName, SUM(CASE WHEN (datediff(Day, RequestedDelivaryDate, CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) 
                         &lt;= 0) THEN 1 ELSE 0 END) AS SumActualRequestedRows, SUM(CASE WHEN (datediff(Day, RequestedDelivaryDate,
                         CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) &lt;= 0) THEN Quantity ELSE 0 END) 
                         AS SumActualRequestedQuantity, SUM(CASE WHEN (datediff(Day, PlannedDelivaryDate, CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) 
                         &lt;= 0) THEN 1 ELSE 0 END) AS SumActualPlannedRows, SUM(CASE WHEN (datediff(Day, PlannedDelivaryDate,
                         CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) &lt;= 0) THEN Quantity ELSE 0 END) 
                         AS SumActualPlannedQuantity, COUNT(*) AS TotalRows, SUM(TableWorkOrder.Quantity) AS TotalQuantity
FROM            TableWorkOrder LEFT OUTER JOIN
                         TableOrganizationRelations ON TableWorkOrder.CustomerId = TableOrganizationRelations.CustomerId AND 
                         TableWorkOrder.ContractorId = TableOrganizationRelations.ContractorId LEFT OUTER JOIN
                         TableOrganizations ON TableOrganizations.OrganizationId = TableWorkOrder.ContractorId
GROUP BY TableWorkOrder.ContractorId, TableOrganizations.OrganizationName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ContractorId" DataSetColumn="ContractorId" />
              <Mapping SourceColumn="OrganizationName" DataSetColumn="OrganizationName" />
              <Mapping SourceColumn="SumActualRequestedRows" DataSetColumn="SumActualRequestedRows" />
              <Mapping SourceColumn="SumActualRequestedQuantity" DataSetColumn="SumActualRequestedQuantity" />
              <Mapping SourceColumn="SumActualPlannedRows" DataSetColumn="SumActualPlannedRows" />
              <Mapping SourceColumn="SumActualPlannedQuantity" DataSetColumn="SumActualPlannedQuantity" />
              <Mapping SourceColumn="TotalRows" DataSetColumn="TotalRows" />
              <Mapping SourceColumn="TotalQuantity" DataSetColumn="TotalQuantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TableOTDCustomersTableAdapter" GeneratorDataComponentClassName="TableOTDCustomersTableAdapter" Name="TableOTDCustomers" UserDataComponentName="TableOTDCustomersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MLYConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TableWorkOrder.CustomerId, TableOrganizations.OrganizationName, SUM(CASE WHEN (datediff(Day,RequestedDelivaryDate,  CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) 
                         &lt;= 0) THEN 1 ELSE 0 END) AS SumActualRequestedRows, SUM(CASE WHEN (datediff(Day, 
           RequestedDelivaryDate,              CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) &lt;= 0) THEN Quantity ELSE 0 END) 
                         AS SumActualRequestedQuantity, SUM(CASE WHEN (datediff(Day,PlannedDelivaryDate, CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) 
                         &lt;= 0) THEN 1 ELSE 0 END) AS SumActualPlannedRows, SUM(CASE WHEN (datediff(Day, PlannedDelivaryDate,
                         CASE WHEN ActualDelivaryDate IS NULL THEN getdate() ELSE ActualDelivaryDate END) &lt;= 0) THEN Quantity ELSE 0 END) 
                         AS SumActualPlannedQuantity, COUNT(*) AS TotalRows, SUM(TableWorkOrder.Quantity) AS TotalQuantity
FROM            TableWorkOrder INNER JOIN
                         TableOrganizations ON TableWorkOrder.CustomerId = TableOrganizations.OrganizationId LEFT OUTER JOIN
                         TableOrganizationRelations ON TableWorkOrder.ContractorId = TableOrganizationRelations.ContractorId AND 
                         TableWorkOrder.CustomerId = TableOrganizationRelations.CustomerId
GROUP BY TableWorkOrder.CustomerId, TableOrganizations.OrganizationName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="OrganizationName" DataSetColumn="OrganizationName" />
              <Mapping SourceColumn="SumActualRequestedRows" DataSetColumn="SumActualRequestedRows" />
              <Mapping SourceColumn="SumActualRequestedQuantity" DataSetColumn="SumActualRequestedQuantity" />
              <Mapping SourceColumn="SumActualPlannedRows" DataSetColumn="SumActualPlannedRows" />
              <Mapping SourceColumn="SumActualPlannedQuantity" DataSetColumn="SumActualPlannedQuantity" />
              <Mapping SourceColumn="TotalRows" DataSetColumn="TotalRows" />
              <Mapping SourceColumn="TotalQuantity" DataSetColumn="TotalQuantity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TableAvgWoDurationTableAdapter" GeneratorDataComponentClassName="TableAvgWoDurationTableAdapter" Name="TableAvgWoDuration" UserDataComponentName="TableAvgWoDurationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MLYConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TableWorkOrder.CustomerId AS OrganizationId, CustomerOrg.OrganizationName, SUM(DATEDIFF(Day, TableWorkOrder.SendDate, 
                         TableWorkOrder.ActualDelivaryDate)) AS TotalDaysPerContractor, SUM(TableWorkOrder.Quantity) AS TotalQuantityPerContractor, COUNT(*) AS CountWO, 
                         SUM(DATEDIFF(Day, TableWorkOrder.SendDate, TableWorkOrder.ActualDelivaryDate) * TableWorkOrder.Quantity) AS DaysQuantity
FROM            TableWorkOrder INNER JOIN
                         TableOrganizations AS CustomerOrg ON TableWorkOrder.CustomerId = CustomerOrg.OrganizationId
GROUP BY TableWorkOrder.CustomerId, CustomerOrg.OrganizationName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrganizationName" DataSetColumn="OrganizationName" />
              <Mapping SourceColumn="TotalDaysPerContractor" DataSetColumn="TotalDaysPerContractor" />
              <Mapping SourceColumn="TotalQuantityPerContractor" DataSetColumn="TotalQuantityPerContractor" />
              <Mapping SourceColumn="OrganizationId" DataSetColumn="OrganizationId" />
              <Mapping SourceColumn="CountWO" DataSetColumn="CountWO" />
              <Mapping SourceColumn="DaysQuantity" DataSetColumn="DaysQuantity" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MLYConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillForContractor" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataForContractor" GeneratorSourceName="FillForContractor" GetMethodModifier="Public" GetMethodName="GetDataForContractor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataForContractor" UserSourceName="FillForContractor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TableWorkOrder.CustomerId AS OrganizationId, CustomerOrg.OrganizationName, SUM(DATEDIFF(Day, TableWorkOrder.SendDate, 
                         TableWorkOrder.ActualDelivaryDate)) AS TotalDaysPerContractor, SUM(TableWorkOrder.Quantity) AS TotalQuantityPerContractor, COUNT(*) AS CountWO, 
                         SUM(DATEDIFF(Day, TableWorkOrder.SendDate, TableWorkOrder.ActualDelivaryDate) * TableWorkOrder.Quantity) AS DaysQuantity
FROM            TableWorkOrder INNER JOIN
                         TableOrganizations AS CustomerOrg ON TableWorkOrder.CustomerId = CustomerOrg.OrganizationId
GROUP BY TableWorkOrder.CustomerId, CustomerOrg.OrganizationName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="MLYConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillForCustomer" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataForCustomer" GeneratorSourceName="FillForCustomer" GetMethodModifier="Public" GetMethodName="GetDataForCustomer" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataForCustomer" UserSourceName="FillForCustomer">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TableWorkOrder.ContractorId AS OrganizationId, TableOrganizations.OrganizationName, SUM(DATEDIFF(Day, TableWorkOrder.SendDate, 
                         TableWorkOrder.ActualDelivaryDate)) AS TotalDaysPerContractor, SUM(TableWorkOrder.Quantity) AS TotalQuantityPerContractor, COUNT(*) AS CountWO, 
                         SUM(DATEDIFF(Day, TableWorkOrder.SendDate, TableWorkOrder.ActualDelivaryDate) * TableWorkOrder.Quantity) AS DaysQuantity
FROM            TableWorkOrder INNER JOIN
                         TableOrganizations ON TableWorkOrder.ContractorId = TableOrganizations.OrganizationId
GROUP BY TableWorkOrder.ContractorId, TableOrganizations.OrganizationName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsAdvancedRpt" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsAdvancedRpt" msprop:Generator_DataSetName="dsAdvancedRpt" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TableSearchTagRating" msprop:Generator_UserTableName="TableSearchTagRating" msprop:Generator_RowDeletedName="TableSearchTagRatingRowDeleted" msprop:Generator_RowChangedName="TableSearchTagRatingRowChanged" msprop:Generator_RowClassName="TableSearchTagRatingRow" msprop:Generator_RowChangingName="TableSearchTagRatingRowChanging" msprop:Generator_RowEvArgName="TableSearchTagRatingRowChangeEvent" msprop:Generator_RowEvHandlerName="TableSearchTagRatingRowChangeEventHandler" msprop:Generator_TableClassName="TableSearchTagRatingDataTable" msprop:Generator_TableVarName="tableTableSearchTagRating" msprop:Generator_RowDeletingName="TableSearchTagRatingRowDeleting" msprop:Generator_TablePropName="TableSearchTagRating">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Tag" msprop:Generator_UserColumnName="Tag" msprop:Generator_ColumnVarNameInTable="columnTag" msprop:Generator_ColumnPropNameInRow="Tag" msprop:Generator_ColumnPropNameInTable="TagColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableQuantityPerMonth" msprop:Generator_UserTableName="TableQuantityPerMonth" msprop:Generator_RowDeletedName="TableQuantityPerMonthRowDeleted" msprop:Generator_RowChangedName="TableQuantityPerMonthRowChanged" msprop:Generator_RowClassName="TableQuantityPerMonthRow" msprop:Generator_RowChangingName="TableQuantityPerMonthRowChanging" msprop:Generator_RowEvArgName="TableQuantityPerMonthRowChangeEvent" msprop:Generator_RowEvHandlerName="TableQuantityPerMonthRowChangeEventHandler" msprop:Generator_TableClassName="TableQuantityPerMonthDataTable" msprop:Generator_TableVarName="tableTableQuantityPerMonth" msprop:Generator_RowDeletingName="TableQuantityPerMonthRowDeleting" msprop:Generator_TablePropName="TableQuantityPerMonth">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SumOfQuantity" msprop:Generator_UserColumnName="SumOfQuantity" msprop:Generator_ColumnPropNameInRow="SumOfQuantity" msprop:Generator_ColumnVarNameInTable="columnSumOfQuantity" msprop:Generator_ColumnPropNameInTable="SumOfQuantityColumn" type="xs:double" minOccurs="0" />
              <xs:element name="WoMonth" msprop:Generator_UserColumnName="WoMonth" msprop:Generator_ColumnPropNameInRow="WoMonth" msprop:Generator_ColumnVarNameInTable="columnWoMonth" msprop:Generator_ColumnPropNameInTable="WoMonthColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ContractorId" msprop:Generator_UserColumnName="ContractorId" msprop:Generator_ColumnPropNameInRow="ContractorId" msprop:Generator_ColumnVarNameInTable="columnContractorId" msprop:Generator_ColumnPropNameInTable="ContractorIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ContractorName" msprop:Generator_UserColumnName="ContractorName" msprop:Generator_ColumnPropNameInRow="ContractorName" msprop:Generator_ColumnVarNameInTable="columnContractorName" msprop:Generator_ColumnPropNameInTable="ContractorNameColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableOTDContractors" msprop:Generator_UserTableName="TableOTDContractors" msprop:Generator_RowDeletedName="TableOTDContractorsRowDeleted" msprop:Generator_RowChangedName="TableOTDContractorsRowChanged" msprop:Generator_RowClassName="TableOTDContractorsRow" msprop:Generator_RowChangingName="TableOTDContractorsRowChanging" msprop:Generator_RowEvArgName="TableOTDContractorsRowChangeEvent" msprop:Generator_RowEvHandlerName="TableOTDContractorsRowChangeEventHandler" msprop:Generator_TableClassName="TableOTDContractorsDataTable" msprop:Generator_TableVarName="tableTableOTDContractors" msprop:Generator_RowDeletingName="TableOTDContractorsRowDeleting" msprop:Generator_TablePropName="TableOTDContractors">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ContractorId" msprop:Generator_UserColumnName="ContractorId" msprop:Generator_ColumnVarNameInTable="columnContractorId" msprop:Generator_ColumnPropNameInRow="ContractorId" msprop:Generator_ColumnPropNameInTable="ContractorIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrganizationName" msprop:Generator_UserColumnName="OrganizationName" msprop:Generator_ColumnVarNameInTable="columnOrganizationName" msprop:Generator_ColumnPropNameInRow="OrganizationName" msprop:Generator_ColumnPropNameInTable="OrganizationNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SumActualRequestedRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualRequestedRows" msprop:Generator_ColumnVarNameInTable="columnSumActualRequestedRows" msprop:Generator_ColumnPropNameInRow="SumActualRequestedRows" msprop:Generator_ColumnPropNameInTable="SumActualRequestedRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SumActualRequestedQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualRequestedQuantity" msprop:Generator_ColumnVarNameInTable="columnSumActualRequestedQuantity" msprop:Generator_ColumnPropNameInRow="SumActualRequestedQuantity" msprop:Generator_ColumnPropNameInTable="SumActualRequestedQuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SumActualPlannedRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualPlannedRows" msprop:Generator_ColumnVarNameInTable="columnSumActualPlannedRows" msprop:Generator_ColumnPropNameInRow="SumActualPlannedRows" msprop:Generator_ColumnPropNameInTable="SumActualPlannedRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SumActualPlannedQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualPlannedQuantity" msprop:Generator_ColumnVarNameInTable="columnSumActualPlannedQuantity" msprop:Generator_ColumnPropNameInRow="SumActualPlannedQuantity" msprop:Generator_ColumnPropNameInTable="SumActualPlannedQuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TotalRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalRows" msprop:Generator_ColumnVarNameInTable="columnTotalRows" msprop:Generator_ColumnPropNameInRow="TotalRows" msprop:Generator_ColumnPropNameInTable="TotalRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TotalQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalQuantity" msprop:Generator_ColumnVarNameInTable="columnTotalQuantity" msprop:Generator_ColumnPropNameInRow="TotalQuantity" msprop:Generator_ColumnPropNameInTable="TotalQuantityColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableOTDCustomers" msprop:Generator_UserTableName="TableOTDCustomers" msprop:Generator_RowDeletedName="TableOTDCustomersRowDeleted" msprop:Generator_RowChangedName="TableOTDCustomersRowChanged" msprop:Generator_RowClassName="TableOTDCustomersRow" msprop:Generator_RowChangingName="TableOTDCustomersRowChanging" msprop:Generator_RowEvArgName="TableOTDCustomersRowChangeEvent" msprop:Generator_RowEvHandlerName="TableOTDCustomersRowChangeEventHandler" msprop:Generator_TableClassName="TableOTDCustomersDataTable" msprop:Generator_TableVarName="tableTableOTDCustomers" msprop:Generator_RowDeletingName="TableOTDCustomersRowDeleting" msprop:Generator_TablePropName="TableOTDCustomers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="OrganizationName" msprop:Generator_UserColumnName="OrganizationName" msprop:Generator_ColumnVarNameInTable="columnOrganizationName" msprop:Generator_ColumnPropNameInRow="OrganizationName" msprop:Generator_ColumnPropNameInTable="OrganizationNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SumActualRequestedRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualRequestedRows" msprop:Generator_ColumnVarNameInTable="columnSumActualRequestedRows" msprop:Generator_ColumnPropNameInRow="SumActualRequestedRows" msprop:Generator_ColumnPropNameInTable="SumActualRequestedRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SumActualRequestedQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualRequestedQuantity" msprop:Generator_ColumnVarNameInTable="columnSumActualRequestedQuantity" msprop:Generator_ColumnPropNameInRow="SumActualRequestedQuantity" msprop:Generator_ColumnPropNameInTable="SumActualRequestedQuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SumActualPlannedRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualPlannedRows" msprop:Generator_ColumnVarNameInTable="columnSumActualPlannedRows" msprop:Generator_ColumnPropNameInRow="SumActualPlannedRows" msprop:Generator_ColumnPropNameInTable="SumActualPlannedRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SumActualPlannedQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SumActualPlannedQuantity" msprop:Generator_ColumnVarNameInTable="columnSumActualPlannedQuantity" msprop:Generator_ColumnPropNameInRow="SumActualPlannedQuantity" msprop:Generator_ColumnPropNameInTable="SumActualPlannedQuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TotalRows" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalRows" msprop:Generator_ColumnVarNameInTable="columnTotalRows" msprop:Generator_ColumnPropNameInRow="TotalRows" msprop:Generator_ColumnPropNameInTable="TotalRowsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TotalQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalQuantity" msprop:Generator_ColumnVarNameInTable="columnTotalQuantity" msprop:Generator_ColumnPropNameInRow="TotalQuantity" msprop:Generator_ColumnPropNameInTable="TotalQuantityColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableAvgWoDuration" msprop:Generator_UserTableName="TableAvgWoDuration" msprop:Generator_RowDeletedName="TableAvgWoDurationRowDeleted" msprop:Generator_RowChangedName="TableAvgWoDurationRowChanged" msprop:Generator_RowClassName="TableAvgWoDurationRow" msprop:Generator_RowChangingName="TableAvgWoDurationRowChanging" msprop:Generator_RowEvArgName="TableAvgWoDurationRowChangeEvent" msprop:Generator_RowEvHandlerName="TableAvgWoDurationRowChangeEventHandler" msprop:Generator_TableClassName="TableAvgWoDurationDataTable" msprop:Generator_TableVarName="tableTableAvgWoDuration" msprop:Generator_RowDeletingName="TableAvgWoDurationRowDeleting" msprop:Generator_TablePropName="TableAvgWoDuration">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrganizationName" msprop:Generator_UserColumnName="OrganizationName" msprop:Generator_ColumnVarNameInTable="columnOrganizationName" msprop:Generator_ColumnPropNameInRow="OrganizationName" msprop:Generator_ColumnPropNameInTable="OrganizationNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalDaysPerContractor" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalDaysPerContractor" msprop:Generator_ColumnVarNameInTable="columnTotalDaysPerContractor" msprop:Generator_ColumnPropNameInRow="TotalDaysPerContractor" msprop:Generator_ColumnPropNameInTable="TotalDaysPerContractorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TotalQuantityPerContractor" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalQuantityPerContractor" msprop:Generator_ColumnVarNameInTable="columnTotalQuantityPerContractor" msprop:Generator_ColumnPropNameInRow="TotalQuantityPerContractor" msprop:Generator_ColumnPropNameInTable="TotalQuantityPerContractorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="OrganizationId" msprop:Generator_UserColumnName="OrganizationId" msprop:Generator_ColumnVarNameInTable="columnOrganizationId" msprop:Generator_ColumnPropNameInRow="OrganizationId" msprop:Generator_ColumnPropNameInTable="OrganizationIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CountWO" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CountWO" msprop:Generator_ColumnVarNameInTable="columnCountWO" msprop:Generator_ColumnPropNameInRow="CountWO" msprop:Generator_ColumnPropNameInTable="CountWOColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DaysQuantity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="DaysQuantity" msprop:Generator_ColumnVarNameInTable="columnDaysQuantity" msprop:Generator_ColumnPropNameInRow="DaysQuantity" msprop:Generator_ColumnPropNameInTable="DaysQuantityColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableQuantityPerMonth2" msprop:Generator_UserTableName="TableQuantityPerMonth2" msprop:Generator_RowDeletedName="TableQuantityPerMonth2RowDeleted" msprop:Generator_RowChangedName="TableQuantityPerMonth2RowChanged" msprop:Generator_RowClassName="TableQuantityPerMonth2Row" msprop:Generator_RowChangingName="TableQuantityPerMonth2RowChanging" msprop:Generator_RowEvArgName="TableQuantityPerMonth2RowChangeEvent" msprop:Generator_RowEvHandlerName="TableQuantityPerMonth2RowChangeEventHandler" msprop:Generator_TableClassName="TableQuantityPerMonth2DataTable" msprop:Generator_TableVarName="tableTableQuantityPerMonth2" msprop:Generator_RowDeletingName="TableQuantityPerMonth2RowDeleting" msprop:Generator_TablePropName="TableQuantityPerMonth2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SumOfQuantity" msprop:Generator_UserColumnName="SumOfQuantity" msprop:Generator_ColumnVarNameInTable="columnSumOfQuantity" msprop:Generator_ColumnPropNameInRow="SumOfQuantity" msprop:Generator_ColumnPropNameInTable="SumOfQuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="WoMonth" msprop:Generator_UserColumnName="WoMonth" msprop:Generator_ColumnVarNameInTable="columnWoMonth" msprop:Generator_ColumnPropNameInRow="WoMonth" msprop:Generator_ColumnPropNameInTable="WoMonthColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ContractorId" msprop:Generator_UserColumnName="ContractorId" msprop:Generator_ColumnVarNameInTable="columnContractorId" msprop:Generator_ColumnPropNameInRow="ContractorId" msprop:Generator_ColumnPropNameInTable="ContractorIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ContractorName" msprop:Generator_UserColumnName="ContractorName" msprop:Generator_ColumnVarNameInTable="columnContractorName" msprop:Generator_ColumnPropNameInRow="ContractorName" msprop:Generator_ColumnPropNameInTable="ContractorNameColumn" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableDeliveredQuantities" msprop:Generator_UserTableName="TableDeliveredQuantities" msprop:Generator_RowDeletedName="TableDeliveredQuantitiesRowDeleted" msprop:Generator_RowChangedName="TableDeliveredQuantitiesRowChanged" msprop:Generator_RowClassName="TableDeliveredQuantitiesRow" msprop:Generator_RowChangingName="TableDeliveredQuantitiesRowChanging" msprop:Generator_RowEvArgName="TableDeliveredQuantitiesRowChangeEvent" msprop:Generator_RowEvHandlerName="TableDeliveredQuantitiesRowChangeEventHandler" msprop:Generator_TableClassName="TableDeliveredQuantitiesDataTable" msprop:Generator_TableVarName="tableTableDeliveredQuantities" msprop:Generator_RowDeletingName="TableDeliveredQuantitiesRowDeleting" msprop:Generator_TablePropName="TableDeliveredQuantities">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Series" msprop:Generator_UserColumnName="Series" msprop:Generator_ColumnVarNameInTable="columnSeries" msprop:Generator_ColumnPropNameInRow="Series" msprop:Generator_ColumnPropNameInTable="SeriesColumn" type="xs:string" minOccurs="0" />
              <xs:element name="DeliveredDate" msprop:Generator_UserColumnName="DeliveredDate" msprop:Generator_ColumnVarNameInTable="columnDeliveredDate" msprop:Generator_ColumnPropNameInRow="DeliveredDate" msprop:Generator_ColumnPropNameInTable="DeliveredDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Quantity" msprop:Generator_UserColumnName="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TableDeliveredQuantities2" msprop:Generator_UserTableName="TableDeliveredQuantities2" msprop:Generator_RowDeletedName="TableDeliveredQuantities2RowDeleted" msprop:Generator_RowChangedName="TableDeliveredQuantities2RowChanged" msprop:Generator_RowClassName="TableDeliveredQuantities2Row" msprop:Generator_RowChangingName="TableDeliveredQuantities2RowChanging" msprop:Generator_RowEvArgName="TableDeliveredQuantities2RowChangeEvent" msprop:Generator_RowEvHandlerName="TableDeliveredQuantities2RowChangeEventHandler" msprop:Generator_TableClassName="TableDeliveredQuantities2DataTable" msprop:Generator_TableVarName="tableTableDeliveredQuantities2" msprop:Generator_RowDeletingName="TableDeliveredQuantities2RowDeleting" msprop:Generator_TablePropName="TableDeliveredQuantities2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DeliveredDate" msprop:Generator_UserColumnName="DeliveredDate" msprop:Generator_ColumnPropNameInRow="DeliveredDate" msprop:Generator_ColumnVarNameInTable="columnDeliveredDate" msprop:Generator_ColumnPropNameInTable="DeliveredDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="QuantityBase" msprop:Generator_UserColumnName="QuantityBase" msprop:Generator_ColumnPropNameInRow="QuantityBase" msprop:Generator_ColumnVarNameInTable="columnQuantityBase" msprop:Generator_ColumnPropNameInTable="QuantityBaseColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="QuantityAdded" msprop:Generator_UserColumnName="QuantityAdded" msprop:Generator_ColumnPropNameInRow="QuantityAdded" msprop:Generator_ColumnVarNameInTable="columnQuantityAdded" msprop:Generator_ColumnPropNameInTable="QuantityAddedColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InventoryBalanceDetails" msprop:Generator_UserTableName="InventoryBalanceDetails" msprop:Generator_RowDeletedName="InventoryBalanceDetailsRowDeleted" msprop:Generator_RowChangedName="InventoryBalanceDetailsRowChanged" msprop:Generator_RowClassName="InventoryBalanceDetailsRow" msprop:Generator_RowChangingName="InventoryBalanceDetailsRowChanging" msprop:Generator_RowEvArgName="InventoryBalanceDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="InventoryBalanceDetailsRowChangeEventHandler" msprop:Generator_TableClassName="InventoryBalanceDetailsDataTable" msprop:Generator_TableVarName="tableInventoryBalanceDetails" msprop:Generator_RowDeletingName="InventoryBalanceDetailsRowDeleting" msprop:Generator_TablePropName="InventoryBalanceDetails">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkOrderNumber" msprop:Generator_UserColumnName="WorkOrderNumber" msprop:Generator_ColumnPropNameInRow="WorkOrderNumber" msprop:Generator_ColumnVarNameInTable="columnWorkOrderNumber" msprop:Generator_ColumnPropNameInTable="WorkOrderNumberColumn" type="xs:string" minOccurs="0" />
              <xs:element name="CustomerCatalogCode" msprop:Generator_UserColumnName="CustomerCatalogCode" msprop:Generator_ColumnPropNameInRow="CustomerCatalogCode" msprop:Generator_ColumnVarNameInTable="columnCustomerCatalogCode" msprop:Generator_ColumnPropNameInTable="CustomerCatalogCodeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ContractorCatalogCode" msprop:Generator_UserColumnName="ContractorCatalogCode" msprop:Generator_ColumnPropNameInRow="ContractorCatalogCode" msprop:Generator_ColumnVarNameInTable="columnContractorCatalogCode" msprop:Generator_ColumnPropNameInTable="ContractorCatalogCodeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" type="xs:string" minOccurs="0" />
              <xs:element name="SendDate" msprop:Generator_UserColumnName="SendDate" msprop:Generator_ColumnPropNameInRow="SendDate" msprop:Generator_ColumnVarNameInTable="columnSendDate" msprop:Generator_ColumnPropNameInTable="SendDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PlannedDeliveryDate" msprop:Generator_UserColumnName="PlannedDeliveryDate" msprop:Generator_ColumnPropNameInRow="PlannedDeliveryDate" msprop:Generator_ColumnVarNameInTable="columnPlannedDeliveryDate" msprop:Generator_ColumnPropNameInTable="PlannedDeliveryDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ActualDeliveryDate" msprop:Generator_UserColumnName="ActualDeliveryDate" msprop:Generator_ColumnPropNameInRow="ActualDeliveryDate" msprop:Generator_ColumnVarNameInTable="columnActualDeliveryDate" msprop:Generator_ColumnPropNameInTable="ActualDeliveryDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Quantity" msprop:Generator_UserColumnName="Quantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Value" msprop:Generator_UserColumnName="Value" msprop:Generator_ColumnPropNameInRow="Value" msprop:Generator_ColumnVarNameInTable="columnValue" msprop:Generator_ColumnPropNameInTable="ValueColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="OrganizationName" msprop:Generator_UserColumnName="OrganizationName" msprop:Generator_ColumnVarNameInTable="columnOrganizationName" msprop:Generator_ColumnPropNameInRow="OrganizationName" msprop:Generator_ColumnPropNameInTable="OrganizationNameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="RequestedDeliveryDate" msprop:Generator_UserColumnName="RequestedDeliveryDate" msprop:Generator_ColumnPropNameInRow="RequestedDeliveryDate" msprop:Generator_ColumnVarNameInTable="columnRequestedDeliveryDate" msprop:Generator_ColumnPropNameInTable="RequestedDeliveryDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>